

--  Contact
DROP PROCEDURE dbo.uspContact_GetAll
GO
DROP PROCEDURE dbo.uspContact_Get
GO
DROP PROCEDURE dbo.uspContact_GetFirst
GO
DROP PROCEDURE dbo.uspContact_GetCount
GO
--  Contact
DROP PROCEDURE dbo.uspContact_GetAll
GO
DROP PROCEDURE dbo.uspContact_Get
GO
DROP PROCEDURE dbo.uspContact_GetFirst
GO
DROP PROCEDURE dbo.uspContact_GetCount
GO
--  Member
DROP PROCEDURE dbo.uspMember_GetAll
GO
DROP PROCEDURE dbo.uspMember_Get
GO
DROP PROCEDURE dbo.uspMember_GetFirst
GO
DROP PROCEDURE dbo.uspMember_GetCount
GO
--  Memo
DROP PROCEDURE dbo.uspMemo_GetAll
GO
DROP PROCEDURE dbo.uspMemo_Get
GO
DROP PROCEDURE dbo.uspMemo_GetFirst
GO
DROP PROCEDURE dbo.uspMemo_GetCount
GO
--  Reading
DROP PROCEDURE dbo.uspReading_GetAll
GO
DROP PROCEDURE dbo.uspReading_Get
GO
DROP PROCEDURE dbo.uspReading_GetFirst
GO
DROP PROCEDURE dbo.uspReading_GetCount
GO
--  ReadingView
DROP PROCEDURE dbo.uspReadingView_GetAll
GO
DROP PROCEDURE dbo.uspReadingView_Get
GO
DROP PROCEDURE dbo.uspReadingView_GetFirst
GO
DROP PROCEDURE dbo.uspReadingView_GetCount
GO

--  Contact
DROP PROCEDURE dbo.uspContact_GetByContactID
GO
DROP PROCEDURE dbo.uspContact_Insert
GO
DROP PROCEDURE dbo.uspContact_Update
GO
DROP PROCEDURE dbo.uspContact_Delete
GO
--  Contact
DROP PROCEDURE dbo.uspContact_GetByContactID
GO
DROP PROCEDURE dbo.uspContact_Insert
GO
DROP PROCEDURE dbo.uspContact_Update
GO
DROP PROCEDURE dbo.uspContact_Delete
GO
--  Member
DROP PROCEDURE dbo.uspMember_GetByMemberID
GO
DROP PROCEDURE dbo.uspMember_Insert
GO
DROP PROCEDURE dbo.uspMember_Update
GO
DROP PROCEDURE dbo.uspMember_Delete
GO
--  Memo
DROP PROCEDURE dbo.uspMemo_GetByMemoID
GO
DROP PROCEDURE dbo.uspMemo_Insert
GO
DROP PROCEDURE dbo.uspMemo_Update
GO
DROP PROCEDURE dbo.uspMemo_Delete
GO
--  Reading
DROP PROCEDURE dbo.uspReading_GetByMemberIDMemoID
GO
DROP PROCEDURE dbo.uspReading_Insert
GO
DROP PROCEDURE dbo.uspReading_Update
GO
DROP PROCEDURE dbo.uspReading_Delete
GO
